Spreadsheet Administration Legend

chan.

Document Version v.3
Document Last Updated 7/30/25
Software Version Documented v.10

Spreadsheet Administrator Legend

This document will go into detail on what each field means in the Spreadsheet headers for Quotes/Orders, RFQ/Purchase Orders, Customer Returns/RMA, and Vendor Return/RTV grids for your specific needs. To review how to administer this spreadsheet, please refer to Spreadsheet Admin Settings documentation***.***

UPDATED: Version 10

R Refresh. If an item is checked, it will refresh when the quote refreshes. Otherwise, the item will not refresh. If you uncheck and check this, it will restore the original item information from the business system such as pricing and cost.
Qty (F2) 10 Quantity. The quantity desired for that line item. Pressing F2 will jump to this field.
Part Number (F3) 9104-pc Part Number for the item. Pressing F3 will jump to this field. This field can be filtered.
S Magnifying Glass on line to search for the Part Number
(+) Description (F4) 8" Shower Arm, P/Chrome Description of the item. Pressing F4 will jump to this field. Double clicking the column header will switch the (+) to a (-) and will widen the row
Vendor CAL Vendor Number for this item. This can be changed by using the Vendor Search for this line item. This field can be filtered
S Magnifying Glass to search for another Vendor to buy the item from rather than the Default Vendor.
Net (F5) $41.00 Net Price of the item (before taxes and freight). Pressing F5 will jump to this field.
U/M E Unit of Measurement. The unit of measurement for the part.
Ext Net $41.00 Extended Net Price of the item (before taxes and freight). (Qty x Net)
Avail Availability. The quantity of the item that is available. If you double click this column, a Warehouse Inventory window will open telling you the inventory levels for that item. It also allows for various selections in the form for Line Item Ship and Bill, Line Item Internal, New Order Internal, Line Item Direct, and Line Item PO Now. Please refer to IBT documentation
Internal Internal Branch Transfer. As above, double clicking the AVAIL allows you to do Inter Branch Transfers in various ways and this checkbox will then be checked.
Warehouse SE Prototype 2 Warehouse that this item is shipping from.
S Warehouse Search for Line Item Internals
OO

On Order. The quantity of the item that is On a Purchase Order.

If you double click this, a Warehouse Inventory window will open, telling you the inventory levels for that item.
Install Location Bedroom Used for Showroom builder quotes, double clicking the Install Location or Label Qty will open the label selector window where you can select multiple labels to be printed for the item. You can have multiple quantities as well as multiple install locations.
Label Qty 1 The Label Quantity that will print out when you print from a label template.
Allocated 1 The quantity that has been Allocated.
Picked 1 The quantity that has been Picked.
Received 0 The quantity that has been Received.
Put Away 0 The quantity that has been Put Away
Held 0 The quantity that has been Held for Backorders.
Shipped 100 The quantity that has been Shipped.
SCAllocated 100 The quantity that has been Ship Complete Allocated
BOReserved 100 Displayed when item or order is manually back ordered. You will see this after conversion and a Purchase Order has been created and received to Held For Backorder, but a Shipper hasn’t been created yet. Upon a Shipper being created, it will return to 0.
Sell Qty 1 Sell Quantity. The sell quantity is the minimum quantity (in multiples) of the item you can sell.
B b Blanket. If a blanket or contract pricing is applied to an item, there will be a “b” in this column.
S Send To Business System. If the send box is checked, the item will be sent to your business system when the Quote or RFQ is converted.
NSB Non Stock Build. If the non stock build box is checked, a new part will be created when the Quote or RFQ is converted.
Margin (F6) 63.44% Margin in percentage (also known as gross margin) for each item. [Margin = Sell Price / (Sell Price
Cost (F7) $14.99 Actual Cost of the item. Pressing F7 will jump to this field.
Cost Multi 0.2998 Cost Multiplier displays what the cost multiplier is based on the cost and list price of the item. This is a system calculated field for display purposes only. Cost / List = Cost Multiplier ($1.25 / $5.00 = 0.25)
Invoice # 02,03 Invoice #(s) that line item is on; will hyperlink to Shipper/Invoice.
LIH Line Item Hold. When the LIH is checked for an item, no quantities will be allocated until the LIH is unchecked.
Ship Comp Ship Complete. When this is checked for an item, a pick ticket will not print until all items have been received.
B/O Back Order. When the backorder is checked for an item, that item is put on back order.
Direct Direct. Check this box for a line item direct or drop ship order. Alternatively, you can do a whole order direct by using the Direct flag in the order header
PO Now

Check this box at the line item to create a Purchase Order immediately for that line item when you convert an order.

Alternatively you can generate a linked RFQ via the links tab at the order level.
Ship & Bill Have a different internal warehouse ship and bill an item. Don’t bring it into your warehouse. Can do that at the line item level.
PO Number 51055 Purchase Order Number that this line is hard linked to and hyperlinks to that Purchase Order. This field can be filtered
RHAllocated 0 The quantity that has been Reserve Held Allocated. Review the documentation on Reserve Hold.
ST Allocated 0 The quantity that has been Store Allocated. Review the documentation on Storage Shippers.
ST Picked 0 The quantity that has been Store Picked. Review the documentation on Storage Shippers
ST Shipped 0 The quantity that has been Stored Shipped. Review the documentation on Storage Shippers.
ST Quantity 0 The quantity that has been Stored Quantity. Review the documentation on Storage Shippers.
ST Remaining 0 The quantity that has been stored, but is remaining. Review the documentation on Storage Shippers.
Freight Allowed For Lot Projects, the column to enable Freight Allowed. Review the documentation on Freight Indicators for Lot Projects

Customer Pays

Freight

 For Lot Projects, the column enables Customer PaysFreight. Review the documentation on Freight Indicators for Lot Projects
UD Cost 1 $0.00 User Defined Cost 1.
UD Cost 2 $0.00 User Defined Cost 2.
UD Cost 3 $0.00 User Defined Cost 3.
UD Cost 4 $0.00 User Defined Cost 4.
UD Cost 5 $0.00 User Defined Cost 5.
S. Tax If Tax is checked, the item will be marked as taxable and include tax. If tax is not checked, the item will not be marked as taxable and will not include tax.
Asset Account Inventory You can choose an Asset Account for the item. Inventory Asset is default
Type Typically used for lighting. Can assign a fixture type for example. This is manually entered.
Extra Qty Lighting column.
Extra Part Number Lighting column.
Extra Unit Cost Lighting column.
Extra Cost Lighting column.
List Price $50.00 List Price of the item.
Multiplier (F8) 0.82 Calculates the sell price based on the list price. [Multiplierr = Net Price(Sell Price) / List Price]. Pressing F8 will jump to this field.
Freight $0.00 Freight cost for the item.
BS Net $41.00 What business system returned as the original sell price for an item per customer. This is dependent on unique customer pricing and is a way to compare what the original sell is against a manual price override.
RC Magnifying glass to search for Reason Code
Variance $0.00 The difference between the new sell price and the original sell price. [Variance = New Sell Price
TSI Trade Service Import. This is a flag denoting a Trade Service / Master Database import.
Delivery Date (F10) 12/1/2023 The line item promised a delivery date. Pressing F10 will jump to this field.
Comment (F11) First comment field. Pressing F11 will jump to the first comment field.
Comment2 Second comment field.
Comment3 Third comment field.
Comment4 Fourth comment field.
Min Qty 0 Minimum Order Quantity is the minimum quantity set at the part number level for this item
Pkg Qty 1 Package Quantity is the amount of items that come in a package for the item.
Requested Part This is populated after an EDI or HSS import. It is the part number that was read from the imported file.
Requested Price This is populated after an EDI or HHS import. It is the price that was read from the imported file.
PartType Obsolete Column Header. Will be removed in future releases.
Warehouse Message Can be defined per item to convey messages to warehouse personnel such as “Large Item” or “Heavy Item”
Customer Seq. # 0 Line item sequence number per customer PO

KitHeader

UniqueIdentifier

 0 Used for kit identification
Average Usage 0 Average usage of an item over a certain period of time.
ROP 50 Reorder Point - is the set quantity to reorder to. if you double click this field, the Warehouse Inventory Status window will appear
ROQ 50 Reorder Quantity -is the set multiples of quantity to reorder to. if you double click this field, the Warehouse Inventory Status window will appear
Lead Days 7 Number of lead days required for this item - if you double click this field, the Warehouse Inventory Status window will appear
Warehouse stock Quantity of items above set point
Last Year's Avg. Cost Shows the average cost of the item from last year.
This Year's Avg. Cost Shows the average cost of the item for this year.
KitShowDetails Right Click on a Kit to Kit Info
UD Classification1 User-Defined Classification 1
UD Classification2 User-Defined Classification 2
UD Classification3 User-Defined Classification 3
UD Classification4 User-Defined Classification 4
UD Classification5 User-Defined Classification 5
Pkg Qty2 10 2nd Package Quantity field
Prices In Print Print or don’t print prices at the item level. (PP) on the Header of the Order.
Alias Part Number Customer Alias part number assigned at Customer level
Warehouse Rank Tells you the rank of the item from a fast/slow movement standpoint. An “A Item” is faster moving than a “B Item”.
Delayed Delayed Order
Due Date 11/16/2023 Date order is due
Buffer Time 15 Relates to delayed Purchase
Purchase Date 12/1/2023
Rebatable Rebatable item
Weight 10 Weightper item
Weight Units 10 Unit for weight
Total Weight 100 Total Weight per line item. (Weight x Weight Units)
Discount % 10% Discount % that is on the Part Number’s price file
Reference Part This is the Commodity Parent Item's Reference Part number.
White Goods Tax In certain states there is a tax called "White Goods Tax".
Serial Number Serial Number(s) for this line item.
Store Checkmarked if this line item must be stored. Please refer to documentation on Storage Shippers
Invoicing Profit % For Lot Project Items, the Invoicing Profit Percentage. Please refer to documentation on Lot Projects
NSB Type Normal For Lot Projects, the dropdown to create a Lot Project, Lot Project Item, or Normal Non Stock Build item
Itemized In Lot Projects, whether this item is itemized or not. Review Lot Project Process documentation
RTV Type On a Vendor Return/RTV the RTV Type i.e. From RMA
Status Unknown Used for RTV/RMA to designate if the material is good, bad, or unknown
Location Suspect On Hand Used for RTV/RMA to designate what Suspect On Hand Return Bin to be used.
S Magnifying Glass on line to search for the Suspect On Hand Returns Location

UPDATED: Version 10

Every column is now filterable in Version 10

Search Part # Please refer to Fast Product Search - KB
ShipFrom Checkmarked if this line item must be ShipFrom. Please refer to documentation Ship From
W/C Ship From Checkmarked if this line item must be W/C ShipFrom. Please refer to documentation Ship From
Returned 0 Please refer to documentation Returned Spreadsheet Column - KB
Return Invoice 51055-00 Invoice this line is returned from and hyperlinks to that Invoice/Shipper. Please refer to documentation Return Invoice - KB TBD
Serial Number(s) New Serial Number(s) field. Please refer to documentation Serial Number Tracking TBD
Restocking Fee Checkmarked if this line item Restocking Fee.
SO Number 51055 Sales Order Number that this line is hard linked on Purchase Order and hyperlinks to that Sales Order.
CounterPick Please refer to documentation POS Widget TBD
Receiver Please refer to documentation Returned Spreadsheet Column - KB